--Update Branch_Information Set BR_Code='VS'
delete from AccessRights_Employees 

delete from USER_LOGINS
Update Branch_Information set HasSwipeFeature=0,LogOutAfterTransaction=0,AppType='Retail'

----if user wants to logout after everytransaction---
------------------------------------------------------------------------------------------------------
--Update Branch_Information set LogOutAfterTransaction=1
------------------------------------------------------------------------------------------------------
----if swipe feature is available
------------------------------------------------------------------------------------------------------
--Update Branch_Information set HasSwipeFeature=1
---------------------------------------------------------------------------------------------------------

Update AccessRightsScreen set DisplayonMenu=0,DisplayonRetail=0 where AccessScreen in ('Sizes List','Fittings List','Colors List','Multi Products')

delete from syskeys

Update AccessRightsScreen set DisplayonMenu=0,DisplayonRetail=0 where AccessScreen in ('Magazine Types','Customer Magazines Link','Customer Magazines Delivery')

Update AccessRightsScreen set DisplayonMenu=0,DisplayonRetail=0 where AccessScreen in ('Rooms','Services','Services and Rooms Linking','Customer Compliments Letter','Customer Medical History List','Customer Compliments','Customer Recurring Deposits List','Shifts List','Shifts Definition')


delete from BankDetails
DELETE FROM Appointments_Sub_Detail
DELETE FROM Appointments_Detail
DELETE FROM Appointments_Master

delete from CashDrawer_Dtl
delete from CashDrawer_Log
delete from CashDrawer_Mst
delete from Customer_Compliments_Letters

DELETE FROM Customer_MedicalHistory_Link
DELETE FROM CustomerComplimentList
DELETE FROM CustomerMedicalHistoryList

delete from Customers
delete from CustomerType_Product_Qty_PriceList

delete from Customer_Types

delete from EndDay_BalancingDtl
delete from EndDay_BalancingMst
delete from Grn_Dtl
delete from Grn_Mst
delete from HoldSales_Dtl
delete from HoldSales_Mst


DELETE FROM Locations_Master where ShopFloor<>'Y'

DELETE FROM Log_Detail
DELETE FROM Log_MASTER

delete from Login_History

delete from Payment_Details
delete from PettyCash
DELETE FROM SetMenuDtls
delete from SetMenuCategories

delete from Product_Qty_PriceList 
delete from Product_Supplier_BarCodes 
delete from Product_Master 

delete from subcategories
delete from Product_Categories_Level2 
delete from Product_Categories_Level1 


delete from Product_StockList

delete from ProductMovement_Dtl
delete from ProductMovement_Mst
delete from Promotions_Detail
delete from Promotions_Master
delete from Purchase_Order_Details
delete from Purchase_Orders
DELETE FROM Purchase_Payment_Details
DELETE FROM Purchase_Inv_Entry_Detail
DELETE FROM Purchase_Inv_Entry_MASTER


DELETE FROM Purchase_Payment_mASTER

DELETE FROM Sales_Payment_Details
DELETE FROM Sales_Payment_MASTER

DELETE FROM Service_Rooms
DELETE FROM Service_Rooms_Linking
DELETE FROM Services_Users_Linking

DELETE FROM Services_MixedServices
DELETE FROM Services_Pricing
DELETE FROM Services_Master

delete from Refund_Detail
delete from Refund_Mst
delete from Repacking_Detail
delete from Repacking_Master

delete from Sales_Dtl
delete from Sales_Mst
delete from Stock_Transactions
delete from StockAdjustment_Dtl
delete from StockAdjustmentMaster

delete from Supplier_Details
--delete from TillSettings
DELETE FROM User_ClockIn_ClockOut

DELETE FROM User_Commissions_Dtl_Overall
DELETE FROM User_Commissions_Detail
DELETE FROM User_Salary_Log
DELETE FROM User_Commissions_mASTER
delete from Unit_Of_Measure
delete from  Vat_Master
delete from PopUpMessages
delete from Products_mixedProducts

delete from Menu_Shifts
delete from MenuProductLinking